Standard List

A standard list is comprised of a set of static or dynamic member elements. These may be selected directly from the data model, imported from a list, or referenced from an existing custom list.

Syntax & Usage

{[Dimension].[Hierarchy].[Member],[Dimension].[Hierarchy].[Member],[Dimension].[Hierarchy].[Member]}
  1. Manually select the elements from the list (orange highlight).
  2. Open the list builder (blue arrow) to import and auto-select a list of elements.
  3. Select an existing custom list. To do this, click the Business Logic icon (green arrow) to expose existing custom lists that have been saved to the data model (green highlight).

Example

This example returns a list of four manufacturers; Acme, Adihash, Esics, and Nuke:

{[manufacturers].[Manufacturer].[Acme],[manufacturers].[Manufacturer].[Adihash],[manufacturers].[Manufacturer].[Esics],[manufacturers].[Manufacturer].[Nuke]}